Sorry, no items in this category."; }
mysqli_free_result($result);
}//end if cid
/******************************** END SHOW ENTIRE CATEGORY *************************************/
/***************************** BEGIN SHOW INDIVIDUAL LISTING ***********************************/
//query database for a listing, display all images and details
//else if($lid) {
else if($lid) {
$sql="SELECT *
FROM $listing_item_table WHERE listing_id = '$lid'
";//selectall the fields from the table
$result = @mysqli_query($connection,$sql);// or die(mysql_error());//query database
$nr = mysqli_num_rows($result);
while($row=mysqli_fetch_array($result)){//while loop to go through each field in the table
$lid=$row['listing_id'];
$item=$row['item'];
$category_id=$row['category_id'];
// $tag=$row['tag'];
$price=$row['price'];
$description=$row['description'];
//Get the Category for the Category_ID Listing
$sql="SELECT *
FROM $listing_category_table
WHERE category_id = '$category_id'
";//select all the fields from the table
$result_category = @mysqli_query($connection,$sql);// or die(mysql_error());//query database
while($row=mysqli_fetch_array($result_category)){//while loop to go through each field in the table
$category=$row['category'];
}
// Got the Category now
$sql="SELECT *
FROM $listing_photos_table
WHERE tag= '$lid'
ORDER BY photo_id DESC
";//selectall the fields from the table
$result_img = @mysqli_query($connection,$sql);// or die(mysql_error());//query database
// begin displaying content for Single Item
$page_title = $item;
include("include/header.php");
?>
Category: '.$category.''; ?>
Edit';}; ?>
Select + next to little pic to see the BIG picture
" name="PhotoBig" width="500px" style="border:1px solid black;" Title="" Alt="">
Price:
Description:
Sorry, That item is no longer posted on this website.";}
}//end else if listing clicked
/***************************** END SHOW INDIVIDUAL LISTING ***********************************/
/***************************** BEGIN SHOW NO LID/CID SELECTION *******************************/
else { // User has not asked to see anything
$page_title = "All Inventory Available";
include("include/header.php");
?>
We hope you find exactly what you are looking for as you browse through this website.
Remember, we help find specific items requested by customers on a regular basis. So, if you do not see what you are looking for within these featured items, please contact us and we'll help you find it.